SUPPORT / SAMPLES & SAS NOTES
Problem Note 67741: The SGRENDER procedure might produce incorrect X-axis labels
 |  |  |  |  |
PROC SGRENDER might produce incorrect X-axis labels when formats are applied to the X-axis variable.
Here is an example:
data dat;
y = 1;
do tp = 0, 1, 123456789012, 1234567890123, 1234567890123456;
tp=int(tp);
y + 2;
output;
end;
run;
y = 1;
do tp = 0, 1, 123456789012, 1234567890123, 1234567890123456;
tp=int(tp);
y + 2;
output;
end;
run;
proc format;
value tpC 1 = 'TP1'
123456789012 = 'TP12'
1234567890123 = 'TP13'
1234567890123456 = 'TP16'
;
run;
value tpC 1 = 'TP1'
123456789012 = 'TP12'
1234567890123 = 'TP13'
1234567890123456 = 'TP16'
;
run;
proc sgrender template=tmpl data=dat;
format tp tpC.;
run;
format tp tpC.;
run;
The following graphic is produced:
The X axis incorrectly shows the values "1E12" and "1E15" instead of "TP13" and "TP16". The same problem can occur when using numeric formats.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M8 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Professional x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 9.4 TS1M5 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.4 TS1M5 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Linux for x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||